SQL: with practice exercises, Learn SQL Fast, on free software by D Armstrong

Author:D Armstrong
Language: eng
Format: mobi, azw3, epub, pdf
Publisher: D Armstrong
Published: 2016-03-11T22:00:00+00:00

Exercise – 7.1

(answer)

List the names and prices of the ten cheapest products.

Bottom

As there is a "TOP", you might expect there to be a "BOTTOM". SQL Server doesn't have this, but you can often still get the last rows of a table. The Products table has a ProductID field, containing an ID number which increases, by a value of one, for each new record added, to ensure the ID field is unique for each record. Knowing this, to get the bottom ten rows, you can use:

SELECT TOP 10 *

FROM Products

ORDER BY ProductID DESC

This will sort the data in the reverse order to how it is stored. Effectively, this makes an upside-down version of the table, and returns the top ten rows, which were at the bottom of the original table, from that.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.